Cody Holmes
Cody Holmes
-
How to Implement Dynamic Dropdown among Two Sheets
A department wanted a way to take a unique list from a project column in one sheet and use that distinct listing as a dropdown for another sheet, which updated every hour. I currently run the below s…8 · -
Re: Creating Color Coded Column
Without knowing the details, your formula should look something like this: =IF(NOT(ISBLANK([Date Received]@row)), "Green", IF(AND(ISBLANK([Date Received]@row), TODAY() - [Expected Date]@row…1 · -
Re: For how much time does the API access token valid.
In my experience, the token is active indefinitely. Basically, it will last as long as you keep the access token active in your Manage API Access Tokens. There are other ways you can deactivate token…1 · -
Re: Countifs
So I would go about it like this... =COUNTM([Column A]:[Column A]) - COUNTM([Column B]:[Column B]) Basically, this formula will count all of the non-blanks in column A and subtract them from the tota…1 · -
Re: How to troubleshoot the error in a formula? I am receiving #UNPARSEABLE error
Hi Sonal, It appears that your suspicion of the -100% is probably correct. You cannot do a mathematical formula where the end result will equal -100% because the percent sign makes the result a strin…1 ·
